LOAD DATA
TRUNCATE 
INTO TABLE gex_bde_amt_prf_tb
TRAILING NULLCOLS 
(line_no                SEQUENCE(MAX)
,date_eff		POSITION(1:11)		"TO_DATE(:date_eff,'YYYY/MM/DD')"                      
,date_maj		POSITION(12:22)		"TO_DATE(:date_eff,'YYYY/MM/DD')"                      
,entite			POSITION(23:37)		CHAR 
,div			POSITION(38:42) 	CHAR
,act			POSITION(43:47) 	CHAR    
,gest			POSITION(48:53)		CHAR
,cl 			POSITION(54:58) 	CHAR
,unites 		POSITION(59:79)		"TO_NUMBER(:unites,'9999999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,frequence		POSITION(80:89)		CHAR
,freq_prod		POSITION(90:99)		CHAR
,type 			POSITION(100:120)	CHAR
,devise_titre		POSITION(121:136)	CHAR
,montant_dev_titre	POSITION(138:155)	"TO_NUMBER(:montant_dev_titre,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,montant		POSITION(157:174)	"TO_NUMBER(:montant,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,provenance 		POSITION(175:184)	CHAR
)                                                                                                      
